The GameStop saga that unfolded in early 2021 was a significant event in financial markets, involving unprecedented activity by retail investors that was amplified by social media and trading technology.
This casestudy looks at how a sentiment of bewilderment spreads in the wallstreetbets subreddit.
| title | text | date | removed_by_category | link_flair_text | full_link | url | id | over_18 | pinned | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | For the GME boys, the only boys that matter on... | Landing on the moon is the ONLY outcome. I am ... | 2020-12-14 12:47:02 | NaN | Shitpost | https://www.reddit.com/r/wallstreetbets/commen... | https://www.reddit.com/r/wallstreetbets/commen... | kcx05d | False | False |
| 1 | Thanks guys 😁 | I used to think 6% was a good ROI, and that 20... | 2020-12-14 11:08:53 | NaN | Storytime | https://www.reddit.com/r/wallstreetbets/commen... | https://www.reddit.com/r/wallstreetbets/commen... | kcvp58 | False | False |
| 2 | Short % of float update. $GME The short squeez... | NaN | 2020-12-26 14:38:04 | NaN | Stocks | https://www.reddit.com/r/wallstreetbets/commen... | https://i.redd.it/rh7p4mu6mj761.jpg | kkjidv | False | False |
| 3 | DOUBLED ON BOOMER OPTIONS; What's Next? | So, finished college, just started working, hu... | 2020-12-26 10:16:32 | NaN | Options | https://www.reddit.com/r/wallstreetbets/commen... | https://www.reddit.com/r/wallstreetbets/commen... | kkgec2 | False | False |
| 4 | GME DD IN JUJUTSU KAISEN | NaN | 2020-12-26 10:03:05 | NaN | Meme | https://www.reddit.com/r/wallstreetbets/commen... | https://v.redd.it/102ovgq19i761 | kkg9aj | False | False |
Let's also get the Gamestop price data.
In addition to a simple moving averaage, let's also calculate the Exponential Moving Average, as it places a greater weight and significance on the most recent data points. The EMA is calculated by applying a weighting factor which decreases exponentially. This means the EMA includes all the price data within its current value. The most recent price has the highest weight, and each preceding price's weight is reduced by the exponential factor. The major benefit of using an EMA over a simple moving average (SMA) is that it reacts faster to recent price changes. This can make it more effective for short-term trading and for data sets with sudden sharp changes.
If someone says “It doesn’t make sense stock X is going down” that means they have 12 reasons it should be going up, but since it doesn’t, it means there must be something they don’t know. So stock X has a lot going on pulling it in the other direction.
This analysis first used the following keywords as a proxy for the sentiment expressing bewilderment:
"feel", "believe", "sense", "why does", "how does", "how come", "how much", "when will", "isn’t it", "wait for", "add to", "should I", "should we", "scale in", "scale out".
but those didn't pick up signal. So another option is to expand the keyword list to also include:
"confused", "don't understand", "what's happening", "can't believe", "surprised",
as well as wallstreetbets-flavored ones
"mind blown", "can't wrap my head around", "baffled", "stumped", "flabbergasted", "scratching my head", "out of the loop", "lost", "in the dark", "can't make heads or tails", "doesn't compute", "doesn't add up", "what the heck", "bamboozled", "puzzled", "thrown for a loop", "at a loss", "what in the stonks",
and the ones expressing giddiness:
"to the moon", "diamond hands", "printing money", "rocketing", "skyrocketing", "moonshot", "going parabolic", "stonks only go up", "tendies", "loaded", "rolling in dough", "yolo'd", "hit the jackpot", "we're rich, baby", "feeling bullish".
The idea is that when those pick up, we’ll know that something has made a strong move.
This is a beginning of refining the bewilderment metric, as well as the broader study on how an idea or even a felling spreads in the markets.
This section labels the title and the text of the dataset as "bewildered", looks at total count and percentage of the bewilderment keywords in our main dataframe of gamestop posts, whether in a post's title or text, so that we can aggregate that either by hour or day, and plot the Gamepost price alongside.
Get posts with keywords
| keyword_count | word_count | keyword_percentage | title | text | date | id | link_flair_text | over_18 | pinned | removed_by_category | full_link | url | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | 100.0 | https://www.wsj.com/articles/melvin-capital-lo... | NaN | 2021-01-31 16:58:35 | l9gdfg | News | False | False | deleted | https://www.reddit.com/r/wallstreetbets/commen... | https://www.reddit.com/r/wallstreetbets/commen... |
| 1 | 6 | 8 | 75.0 | Did Robinhood pull $GME!? TendiesTendies Tendi... | NaN | 2021-01-28 13:40:53 | l6wue4 | Chart | False | False | NaN | https://www.reddit.com/r/wallstreetbets/commen... | https://i.redd.it/mkzwojp2u2e61.jpg |
| 2 | 2 | 4 | 50.0 | How does gamestop feel? | NaN | 2021-01-28 15:32:06 | l6zsqu | Meme | False | False | moderator | https://www.reddit.com/r/wallstreetbets/commen... | https://i.redd.it/nfn5j01xd3e61.jpg |
| 3 | 1 | 2 | 50.0 | GME Tendies | NaN | 2021-01-15 02:36:06 | kxl29j | Gain | False | False | NaN | https://www.reddit.com/r/wallstreetbets/commen... | https://i.redd.it/641e5tdmreb61.jpg |
| 4 | 1 | 2 | 50.0 | $GME Tendies | NaN | 2021-01-13 16:03:50 | kwjet0 | Gain | False | False | moderator | https://www.reddit.com/r/wallstreetbets/commen... | https://i.redd.it/9o13ednwh4b61.jpg |
Aggregate Data by hour or by day
| total_mentions | total_tokens | percentage | |
|---|---|---|---|
| date | |||
| 2021-01-03 07:00:00 | 1 | 8 | 12.500000 |
| 2021-01-07 16:00:00 | 2 | 22 | 9.090909 |
| 2020-12-12 10:00:00 | 2 | 22 | 9.090909 |
| 2021-01-05 14:00:00 | 1 | 20 | 5.000000 |
| 2021-01-02 04:00:00 | 1 | 31 | 3.225806 |
| ... | ... | ... | ... |
| 2021-01-27 12:00:00 | 0 | 0 | NaN |
| 2021-01-27 13:00:00 | 0 | 0 | NaN |
| 2021-02-04 02:00:00 | 0 | 0 | NaN |
| 2021-02-04 03:00:00 | 0 | 0 | NaN |
| 2021-02-04 04:00:00 | 0 | 0 | NaN |
1384 rows × 3 columns
Plot total keywords counts together with GME price.
Look at total keyword percentage of all chatter.
This graph also includes annotations of the three major developments of the GameStop saga:
Look at percentage of all chatter PER KEYWORD
| feel | believe | sense | why does | how does | how come | how much | when will | isn’t it | wait for | add to | should I | should we | scale in | scale out | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| date | |||||||||||||||
| 2020-12-08 | 0.000000 | 0.048042 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2020-12-09 | 0.034892 | 0.034892 | 0.013957 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2020-12-10 | 0.097609 | 0.000000 | 0.048804 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2020-12-11 | 0.024405 | 0.048810 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2020-12-12 | 0.000000 | 0.104167 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Next steps:
July 27, 2020: Roaring Kitty, aka Keith Gill, starts posting YouTube videos on GameStop here, saying he sees value in the heavily shorted stock he had been investing in since
June 2019. Gill also posts on the Reddit forum WallStreetBets under the name DeepF***ingValue, according to an interview in the Wall Street Journal.
Dec 8, 2020: GameStop shares tank after company misses Wall Street estimates for quarterly revenue as pandemic-led store closures and intense competition from digital-game sellers hit sales.
Jan 11: GameStop appoints Chewy.com founder and two other e-commerce veterans to its board in a deal with investor Ryan Cohen’s RC Ventures, as it doubles down on digital sales.
Jan 12: Short interest at 70.9 mln shares, down from 71.2 mln on Jan 8, per S3 Partners. Notional value of short bets rose to $1.4 bln from $1.3 bln, reflecting the rising stock price.
Jan 13: GameStop shares rise 57%, followed by another 27% jump the next day to $39.90. Its median target price among analysts is $12.50.
Jan 19: Short seller Citron Research takes aim. Tweets about GameStop, saying buyers at these levels are “the suckers at this poker game” and stock “back to $20 fast.”
Jan 20: Citron Research delays negative report, says it does not want to go live with its report on the stock.
Jan 22: Shares rise another 50%.
Jan 25: GameStop stock soars as much 144% then settles up 18% with retail traders storming in to buy more.
Jan 25: Hedge fund Melvin Capital Management receives $2.75 billion investment from Citadel, the Chicago-based hedge fund led by Ken Griffin, and billionaire investor Steven A. Cohen’s Point72 Asset Management, after losing on a series of short bets, including on GameStop. Griffin also founded Citadel Securities, one of several market making firms that pays to execute customer orders from Robinhood.
Jan 26: Elon Musk tweets "Gamestonk!!", along with a link to Reddit's Wallstreetbets stock trading discussion group, where supporters refer to the Tesla CEO as "Papa Musk."
Jan 26: Shares surge 92.7%. Top securities regulator in Massachusetts reportedly says trading in GameStop suggests there is something “systemically wrong” with the options trading.
Jan 27: Trading volumes in U.S. cash equities and options hit all-time record levels at 24.5 billion shares traded and 57.1 million contracts traded.
Jan 27: GameStop hits a closing high of $347.51.
Jan 27: Melvin Capital and Citron close the majority of their GameStop position at a loss.
Jan 28: Robinhood, along with several other brokerages, restricts trading in GameStop and a handful of stocks after the regulatory deposit requirements for settling the securities skyrocket. With buying restricted at many brokerages, but selling allowed, the stocks sell off.
Jan 28: The U.S. House Financial Services and Senate Banking committees says to hold a Feb. 18 hearing on the stock market following the trading restrictions.
Jan 29: Robinhood begins easing trading restrictions on stocks caught up in the so-called Reddit rally.
Feb 1: Robinhood raises $2.4 billion in capital after raising $1 billion the previous week.
Feb 2: U.S. Treasury Secretary Janet Yellen calls meeting of top financial regulators to discuss market volatility driven by retail trading in GameStop and other stocks.
Feb 4: Robinhood removes all trading curbs. The following day, GameStop hits a session high of $95 and closes up 19.20% at $63.77.
Feb 9: GameStop trading at around $40 a share.
Feb 18: U.S. House panel holds hearing titled: "Game Stopped? Who Wins and Loses When Short Sellers, Social Media, and Retail Investors Collide here."